CREATE TABLE [dbo].[TabMDFE] (
  [ID] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [TipoEmissao] varchar(50) COLLATE Latin1_General_CI_AS,
  [Modal] varchar(50) COLLATE Latin1_General_CI_AS,
  [UFIni] varchar(2) COLLATE Latin1_General_CI_AS,
  [UFFim] varchar(2) COLLATE Latin1_General_CI_AS,
  [CodMunCarreg] int,
  [MunCarreg] varchar(80) COLLATE Latin1_General_CI_AS,
  [RNTRC] varchar(30) COLLATE Latin1_General_CI_AS,
  [CIOT] varchar(50) COLLATE Latin1_General_CI_AS,
  [VeiculoTracaoCodInt] varchar(5) COLLATE Latin1_General_CI_AS,
  [VeiculoTracaoPlaca] varchar(10) COLLATE Latin1_General_CI_AS,
  [VeiculoTracaoRenavan] varchar(30) COLLATE Latin1_General_CI_AS,
  [VeiculoTracaoTara] money,
  [VeiculoTracaoCapacidade] money,
  [VeiculoTracaoCapM3] money,
  [VeiculoTracaoTipoRod] varchar(50) COLLATE Latin1_General_CI_AS,
  [VeiculoTracaoTipoCarga] varchar(50) COLLATE Latin1_General_CI_AS,
  [VeiculoTracaoUF] varchar(2) COLLATE Latin1_General_CI_AS,
  [CondutorNome] varchar(60) COLLATE Latin1_General_CI_AS,
  [CondutorCPF] varchar(30) COLLATE Latin1_General_CI_AS,
  [VeiculoReboqueCodInt] varchar(5) COLLATE Latin1_General_CI_AS,
  [VeiculoReboquePlaca] varchar(10) COLLATE Latin1_General_CI_AS,
  [VeiculoReboqueRenavan] varchar(30) COLLATE Latin1_General_CI_AS,
  [VeiculoReboqueTara] money,
  [VeiculoReboqueCapacidade] money,
  [VeiculoReboqueCapM3] money,
  [VeiculoReboqueTipoRod] varchar(50) COLLATE Latin1_General_CI_AS,
  [VeiculoReboqueTipoCarga] varchar(50) COLLATE Latin1_General_CI_AS,
  [VeiculoReboqueUF] varchar(2) COLLATE Latin1_General_CI_AS,
  [ValePedCNPJForn] varchar(30) COLLATE Latin1_General_CI_AS,
  [ValePedCNPJPg] varchar(30) COLLATE Latin1_General_CI_AS,
  [ValePedNumCompra] varchar(50) COLLATE Latin1_General_CI_AS,
  [QtdCTE] int,
  [ValorTotal] money,
  [PesoTotalCarga] money,
  [UnidadeMedidaCarga] varchar(30) COLLATE Latin1_General_CI_AS,
  [Observacoes] varchar(255) COLLATE Latin1_General_CI_AS,
  [InformacoesFisco] varchar(255) COLLATE Latin1_General_CI_AS,
  [NumManifesto] int,
  [QtdNFE] int,
  [CodMunDescarga] int,
  [MunDescarga] varchar(80) COLLATE Latin1_General_CI_AS,
  [NumMDFE] varchar(20) COLLATE Latin1_General_CI_AS,
  [Data] datetime,
  [Status] varchar(20) COLLATE Latin1_General_CI_AS,
  [LocalXML] varchar(250) COLLATE Latin1_General_CI_AS,
  PRIMARY KEY CLUSTERED ([ID])
)
ON [PRIMARY]
GO






CREATE TABLE [dbo].[TabMDFECte] (
  [ID] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [IDMdfe] int,
  [ChaveCTE] varchar(60) COLLATE Latin1_General_CI_AS,
  [TipoUnTransporte] varchar(30) COLLATE Latin1_General_CI_AS,
  [PlacaUnTransporte] varchar(10) COLLATE Latin1_General_CI_AS,
  [Lacre] varchar(60) COLLATE Latin1_General_CI_AS,
  [NumLacre] varchar(60) COLLATE Latin1_General_CI_AS,
  [TipoUnCarga] varchar(60) COLLATE Latin1_General_CI_AS,
  [IdUnCarga] varchar(60) COLLATE Latin1_General_CI_AS,
  [LacreUnCarga] varchar(60) COLLATE Latin1_General_CI_AS,
  [ValorCTE] money,
  PRIMARY KEY CLUSTERED ([ID])
)
ON [PRIMARY]
GO





CREATE TABLE [dbo].[TabMDFENFe] (
  [ID] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [IDMdfe] int,
  [ChaveNFE] varchar(60) COLLATE Latin1_General_CI_AS,
  [TipoUnTransporte] varchar(30) COLLATE Latin1_General_CI_AS,
  [PlacaUnTransporte] varchar(10) COLLATE Latin1_General_CI_AS,
  [Lacre] varchar(60) COLLATE Latin1_General_CI_AS,
  [NumLacre] varchar(60) COLLATE Latin1_General_CI_AS,
  [TipoUnCarga] varchar(60) COLLATE Latin1_General_CI_AS,
  [IdUnCarga] varchar(60) COLLATE Latin1_General_CI_AS,
  [LacreUnCarga] varchar(60) COLLATE Latin1_General_CI_AS,
  [ValorNFE] money,
  PRIMARY KEY CLUSTERED ([ID])
)
ON [PRIMARY]
GO


ALTER TABLE [dbo].[TabMDFE]
ADD [UFPer] varchar(200)
GO